import pandas as pd

df = pd.read_excel("C:\\Users\\user\\Desktop\\result-2.xlsx")
data_list = df.values.tolist()

a = 0
b = 0
for mylist in data_list:

    if mylist[0] in f"{mylist[3]}":
        a = a + 1
        mylist[5] = "正确"
    else:
        b = b + 1
        mylist[5] = "不正确"

df_from_list = pd.DataFrame(data_list)
df_from_list.to_excel('C:\\Users\\user\\Desktop\\福州汇总820-源.xlsx', index=False)
print("正确", a)
print("不正确", b)
print("总", a + b)
